package com.huabo.system.mysql.mapper;

import com.hbfk.util.PageInfo;
import com.huabo.system.mysql.entity.TblRoleMySql;

import java.math.BigDecimal;


public class TblRoleMySqlMapperConfig {
	
	public String selectAllRoleListToYinMai(Integer orgId) {
		String sql = "SELECT RID,RNAME,RDESC,RSTATUS,PKYMROLEID,ORG.PKYMORGID,ORG.ORGNAME FROM TBL_ROLE TR LEFT JOIN TBL_ORGANIZATION ORG ON TR.COMPANYID = ORG.ORGID";
		if(orgId != null) {
			sql += " WHERE TR.COMPANYID = "+orgId;
		}
		return sql;
	}
    
}